<${r"#"}assign prefixName = true>
<#list entityMapper.fieldMapperMap?values as fieldMapper>
<${r"#"}if (where_and_eq_${fieldMapper.code}??)>
<${r"#"}if (where_and_eq_${fieldMapper.code}_value??)>
${r"${prefixName?string('WHERE ', 'AND ')}"}${fieldMapper.columnName} = :where_and_eq_${fieldMapper.code}_value
<${r"#"}else>
${r"${prefixName?string('WHERE ', 'AND ')}"}<#if fieldMapper.typeCode == 'String'>(${fieldMapper.columnName} IS NULL OR ${fieldMapper.columnName} = '')<#else>${fieldMapper.columnName} IS NULL</#if>
</${r"#"}if>
<${r"#"}assign prefixName = false>
</${r"#"}if>
</#list>